Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Report Viewer Help Doc

Home Register
Log In
By Report Viewer Help Doc
SILVER01HDW
9/11/2015
10:53:22 PM		Jeff -

Is there an updated doc available or am I missing something regarding the report viewer for the Silver version I'm using. The examples on the document I'm reading look much different and I'm having a hard time following along to understand the report viewer.

Suggestions?

Thanks,

KP

Reply
jeff
9/12/2015
10:49:37 AM		I agree - the Reading The Reports Help Doc is out of date and does not contain screenshots of the Silver HTML Reports.

That said, if you can bear with me (it may take a bit depending on how my race day shakes out) I'll log into the program as a Silver user - generate some html reports for today's stakes race at Belmont (SAT 09-12-2015 R9) - upload .html files to the JCapper server - and then come back to this thread and post descriptions of what's displayed on the reports.


-jp

.


Reply
jeff
9/12/2015
11:44:12 AM		Silver HTML Report - Playlist File Mode

Link to Silver HTML Report for BEL 09-12-2015 R9:
http://www.JCapper.com/Messageboard/Reports/BEL09122015_PL_R9.html

The following "Key" contains column headers as they appear (left to right) on the report along with the factor displayed in each column:


-------------	--------------------------------------------------------------------------------------
Column Header	Factor
-------------	--------------------------------------------------------------------------------------
           PP   Saddle cloth number/ betting interest identifier
         Name   Name of horse
-------------	--------------------------------------------------------------------------------------
        UProb   UPRMLProb = a probability estimate generated using SilverRating and morning line odds
           OL   Odds Line = ((1/UPRMLProb) - 1)
-------------	--------------------------------------------------------------------------------------
        CPace   CPace numeric value (rank in parenthesis)
         EaCN   EarlyConsensus numeric value (rank in parenthesis)
     E1(gray)   CompoundE1 numeric value (rank in parenthesis)
     E2(gray)   CompoundE2 numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
           TP   TPace rank - click to see numeric value
           SP   SustainedPace rank - click to see numeric value 
     AP(gray)   CompoundAP rank - click to see numeric value
     SP(gray)   CompoundSP rank - click to see numeric value
-------------	--------------------------------------------------------------------------------------
          PAL   Pace Adjustsed Late rank - click to see numeric value
           L3   Late Pace rank best of last 3 - click to see numeric value
           CL   CompoundLate rank - click to see numeric value
           TT   Compound Turn Time rank - click to see numeric value
-------------	--------------------------------------------------------------------------------------
         WFig   Weighted Figure numeric value (rank in parenthesis)
        Style   HDW Run Style - with tic mark and ALT QSpeedPoints
         PctE   PercentEarly numeric value (rank in parenthesis)
         PFit   CompoundPaceFit numeric value (rank in parenthesis)
        LSlnt   Late Slant Fig numeric value (rank in parenthesis)
        HType   HorseType
-------------	--------------------------------------------------------------------------------------
        MLOR5   Morning Line Odds divided by UPRMLProb Odds Line
          QSP   QSpeedPoints (rank in parenthesis)
          PED   HDW Distance Pedigree Rating (rank in parenthesis)
           DT   Distance Shift
-------------	--------------------------------------------------------------------------------------
          AFR   Advanced Form Rating numeric value (rank in parenthesis)
          CFA   Competitive Figure Ability numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
         Form   FormRating numeric value (rank in parenthesis)
         WoBr   Workout Brilliance numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
          SOR   Race Strength rank - click to see numeric value 
          PSR   HDW Projected Speed Rating rank - click to see numeric value
-------------	--------------------------------------------------------------------------------------
        PwrCN   PowerConsensus numeric value (rank in parenthesis)
   UPR/Silver   Silver Rating numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
           ML   Morning Line Odds 
          Rec   Recent Activity Days Last Start
            T   Grade for Trainer (IGNORE THIS! It's out of date!)
-------------	--------------------------------------------------------------------------------------
       Jockey   Jockey Name
      Trainer   Trainer Name
-------------	--------------------------------------------------------------------------------------



Note: SQL Mode Silver HTML Report to follow.



-jp

.




Reply
jeff
9/12/2015
1:33:11 PM		Silver HTML Report - SQL Mode

About SQL Mode HTML Reports:

Unlike the report layout of the playlist file mode html report (which is "canned" or "hard coded" into the program) - the SQL Mode HTML Report Layout can be customized by the user.

The Silver SQL Mode HTML Report displayed at the link presented below does contain one added customization:

Prior to generating the report, I brought up the Factor Setup Tool. On Screen Two I removed JPRMLProb from slot #01 and replaced it with UPRMLProb.

I did this because JPR is not supported in JCapper Silver. In JCapper Silver SilverRating is the supported power rating and SilverRating and UPR are one and the same thing.

From there, while still on Screen Two I hit the Save button and kept hitting the Next button until I came to the Deatil Screen.

Then, in the Detail Screen I highlighted slot 01 in Column1 on the report layout and changed the column header text from JPRProb to UPRProb and hit the Save button.

At that point (with the one customization I wanted to do for this post out of the way) I x-ed out of the Factor Setup Tool, used Scratch Bot to parse the XML, verified that there were a few early scratches for BEL, and went into the User Sys Defs Screen where I checked the box to operate JCapper in SQL Mode, hit the Save button, x-ed out of the User Sys Defs Screen - and ran a SQL Mode Calc Races for BEL R9 to generate the linked to report.

Screenshots:
here
-and-
here

Note: Here's a link to a 4 part web tutorial that covers the Factor Setup Tool in more depth than what I posted above:
http://www.jcapper.com/Article_AddJRating.html

Okay, with that bit of background info out of the way, here's a link to a Silver HTML Report for BEL 09-12-2015 R9:
http://www.JCapper.com/Messageboard/Reports/BEL09122015_SQL_R9.html

The following "Key" contains column headers as they appear (left to right) on the report along with the factor displayed in each column:


-------------	--------------------------------------------------------------------------------------
Column Header	Factor
-------------	--------------------------------------------------------------------------------------
           PP   Saddle cloth number/ betting interest identifier
         Name   Name of horse
-------------	--------------------------------------------------------------------------------------
      UPRProb   UPRMLProb = a probability estimate generated using SilverRating and morning line odds
           OL   Odds Line = ((1/UPRMLProb) - 1)
           ML   Morning Line Odds (rank in parenthesis)
        MLOR3   Morning Line Odds divided by UPRProb Odds Line (I really should have changed the 
                column header text for this from MLOR3 to MLOR5 before posting.)
-------------	--------------------------------------------------------------------------------------
        CPace   CPace numeric value (rank in parenthesis)
          PMI   PMI num val (rank in parenthesis) shown as 0's because PMI not supported in Silver
                Silver users would use the Setup Tool to display an alternate factor in this slot

         PFit   CompoundPaceFit numeric value (rank in parenthesis)
         EaCN   EarlyConsensus numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
          AFR   Advanced Form Rating numeric value (rank in parenthesis)
         Form   Form Rating numeric value (rank in parenthesis)
       WBrill   Workout Brilliance numeric value (rank in parenthesis)
        FmCn    Form Consensus numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
	 WFig   Weigthed Figure numeric value (rank in parenthesis)
        TPace   TPace numeric value (rank in parenthesis)
          CFA   CFA numeric value (rank in parenthesis)
         FgCn   Fig Consensus numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
          PAL   Pace Adjustsed Late rank - click to see numeric value
           L3   Late Pace rank best of last 3 - click to see numeric value
         CpLt   CompoundLate rank - click to see numeric value
         LtCn   Late Consensus rank - click to see numeric value
-------------	--------------------------------------------------------------------------------------
         Rstr   Race Strength numeric value (rank in parenthesis)
          Ped   HDW Distance Pedigree Rating rank - click to see numeric value
         PCls   PClass numeric value (rank in parenthesis)
         ClCn   Class Consensus numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
           OP   OptPts num val (rank in parenthesis) shown as 0's because OptPts not supported in Silver
                Silver users would use Setup Tool to display an alternate factor in this slot

          Stg   Stage Readiness - shown as 0's because factor not supported in Silver
                Silver users would use Setup Tool to display an alternate factor in this slot

           RC   RouteCycle (1=yes 0=no)
         CRun   CantRunXFormAttribute (0=clean 1=dirty 2=cantrun)
-------------	--------------------------------------------------------------------------------------
       RStyle   HDW RunStyle (upper/lower case with tic marks)
         QSpd   QSpeedPoints
          Yrs   AgeOfHorse
          Sex   Sex of horse
-------------	--------------------------------------------------------------------------------------
         FCyc   JCapper Form Cycle (1-8)
          Rec   Recent Activity Days Last Start
           Wo   Recent Activity Days Last Work
           DT   Distance Shift
-------------	--------------------------------------------------------------------------------------
          JPR   JPR num val (rank in parenthesis) shown as 0's because JPR not supported in Silver
                Silver users should use Setup Tool to display an alternate factor in this slot

          UPR   SilverRating numeric value (rank in parenthesis)

          ALC   Alchemy num val (rank in parenthesis) shown as 0's factor not supported in Silver
                Silver users should use Setup Tool to display an alternate factor in this slot
        
         PwCn   Power Consensus numeric value (rank in parenthesis)
-------------	--------------------------------------------------------------------------------------
          CXN   Connection Rating rank - click to see numeric value 
          Jky   Rider Win Pct
          TNR   Trainer Win Pct
          Drv   Drive Type
-------------	--------------------------------------------------------------------------------------
         Sire   Name of Sire
        Rider   Jockey Name
      Trainer   Trainer Name
          Dam   Name of Dam
-------------	--------------------------------------------------------------------------------------






-jp

.


Reply
SILVER01HDW
9/13/2015
2:38:08 PM		Jeff,

Really appreciate you taking the time to post this.

KP

Reply
Reply
Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com